home *** CD-ROM | disk | FTP | other *** search
/ Winzipper / Winzipper_ISO.iso / nt4.0 server / INETSRV / SCRIPTS / SAMPLES / REGISTER.IDC < prev    next >
Encoding:
Text File  |  1996-07-31  |  449 b   |  16 lines
  1. Datasource: Web SQL
  2. Username: sa
  3. Template: register.htx
  4. RequiredParameters: FirstName, LastName
  5. SQLStatement:
  6. + if exists (
  7. +    select * from Guests 
  8. +    where FirstName='%FirstName%' and LastName='%LastName%'
  9. +    )
  10. +      select result='duplicate'
  11. +else
  12. +  INSERT INTO Guests
  13. +  (FirstName, LastName, Email, Homepage, Comment, WebUse)
  14. +  VALUES('%FirstName%', '%LastName%', '%Email%', '%Homepage%', 
  15. +   '%Comment%', '%WebUse%');
  16.